<?php
define("EW_PAGE_ID", "view", TRUE); // Page ID
define("EW_TABLE_NAME", 'osj-applications', TRUE);
?>
<?php 
session_start(); // Initialize session data
ob_start(); // Turn on output buffering
?>
<?php include "osj-ewcfg50.php" ?>
<?php include "osj-ewmysql50.php" ?>
<?php include "osj-phpfn50.php" ?>
<?php include "osj-osj2dapplicationsinfo.php" ?>
<?php include "osj-userfn50.php" ?>
<?php include "osj-osj2dusersinfo.php" ?>
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified
header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1 
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
?>
<?php

// Open connection to the database
$conn = ew_Connect();
?>
<?php
$Security = new cAdvancedSecurity();
?>
<?php
if (!$Security->IsLoggedIn()) $Security->AutoLogin();
$Security->LoadCurrentUserLevel('osj-applications');
if (!$Security->IsLoggedIn()) {
	$Security->SaveLastUrl();
	Page_Terminate("osj-login.php");
}
if (!$Security->CanView()) {
	$Security->SaveLastUrl();
	Page_Terminate("osj-osj2dapplicationslist.php");
}
if ($Security->IsLoggedIn() && $Security->CurrentUserID() == "") {
	$_SESSION[EW_SESSION_MESSAGE] = "You do not have the right permission to view the page";
	Page_Terminate("osj-login.php");
}
?>
<?php

// Common page loading event (in userfn*.php)
Page_Loading();
?>
<?php

// Page load event, used in current page
Page_Load();
?>
<?php
$osj2Dapplications->Export = @$_GET["export"]; // Get export parameter
$sExport = $osj2Dapplications->Export; // Get export parameter, used in header
$sExportFile = $osj2Dapplications->TableVar; // Get export file, used in header
?>
<?php
if (@$_GET["application_id"] <> "") {
	if ($sExportFile <> "") $sExportFile .= "_";
	$sExportFile .= ew_StripSlashes($_GET["application_id"]);
}
if ($osj2Dapplications->Export == "html") {

	// Printer friendly, no action required
}
if ($osj2Dapplications->Export == "xml") {
	header('Content-Type: text/xml');
	header('Content-Disposition: attachment; filename=' . $sExportFile .'.xml');
}
if ($osj2Dapplications->Export == "csv") {
	header('Content-Type: application/csv');
	header('Content-Disposition: attachment; filename=' . $sExportFile .'.csv');
}
?>
<?php

// Paging variables
$nStartRec = 0; // Start record index
$nStopRec = 0; // Stop record index
$nTotalRecs = 0; // Total number of records
$nDisplayRecs = 1;
$nRecRange = 10;

// Load current record
$bLoadCurrentRecord = FALSE;
if (@$_GET["application_id"] <> "") {
	$osj2Dapplications->application_id->setQueryStringValue($_GET["application_id"]);
} else {
	$bLoadCurrentRecord = TRUE;
}

// Get action
if (@$_POST["a_view"] <> "") {
	$osj2Dapplications->CurrentAction = $_POST["a_view"];
} else {
	$osj2Dapplications->CurrentAction = "I"; // Display form
}
switch ($osj2Dapplications->CurrentAction) {
	case "I": // Get a record to display
		$nStartRec = 1; // Initialize start position
		$rs = LoadRecordset(); // Load records
		$nTotalRecs = $rs->RecordCount(); // Get record count
		if ($nTotalRecs <= 0) { // No record found
			$_SESSION[EW_SESSION_MESSAGE] = "No records found"; // Set no record message
			Page_Terminate("osj-osj2dapplicationslist.php"); // Return to list page
		} elseif ($bLoadCurrentRecord) { // Load current record position
			SetUpStartRec(); // Set up start record position

			// Point to current record
			if (intval($nStartRec) <= intval($nTotalRecs)) {
				$rs->Move($nStartRec-1);
			}
		} else { // Match key values
			$bMatchRecord = FALSE;
			while (!$rs->EOF) {
				if (strval($osj2Dapplications->application_id->CurrentValue) == strval($rs->fields('application_id'))) {
					$bMatchRecord = TRUE;
					break;
				} else {
					$nStartRec++;
					$rs->MoveNext();
				}
			}
			if (!$bMatchRecord) {
				$_SESSION[EW_SESSION_MESSAGE] = "No records found"; // Set no record message
				Page_Terminate("osj-osj2dapplicationslist.php"); // Return to list
			} else {
				$osj2Dapplications->setStartRecordNumber($nStartRec); // Save record position
			}
		}
		LoadRowValues($rs); // Load row values
}

// Export data only
if ($osj2Dapplications->Export == "xml" || $osj2Dapplications->Export == "csv") {
	ExportData();
	Page_Terminate(); // Terminate response
}

// Set return url
$osj2Dapplications->setReturnUrl("osj-osj2dapplicationsview.php");

// Render row
$osj2Dapplications->RowType = EW_ROWTYPE_VIEW;
RenderRow();
?>
<?php include "osj-header.php" ?>
<script type="text/javascript">
<!--
var EW_PAGE_ID = "view"; // Page id
var EW_SHOW_HIGHLIGHT = "Show highlight"; 
var EW_HIDE_HIGHLIGHT = "Hide highlight";

//-->
</script>
<script language="JavaScript" type="text/javascript">
<!--

// Write your client script here, no need to add script tags.
// To include another .js script, use:
// ew_ClientScriptInclude("my_javascript.js"); 
//-->

</script>
<p><span class="phpmaker">View TABLE: Applications
<?php if ($osj2Dapplications->Export == "") { ?>
&nbsp;&nbsp;<a href="osj-osj2dapplicationsview.php?export=html&application_id=<?php echo urlencode($osj2Dapplications->application_id->CurrentValue) ?>">Printer Friendly</a>
&nbsp;&nbsp;<a href="osj-osj2dapplicationsview.php?export=xml&application_id=<?php echo urlencode($osj2Dapplications->application_id->CurrentValue) ?>">Export to XML</a>
&nbsp;&nbsp;<a href="osj-osj2dapplicationsview.php?export=csv&application_id=<?php echo urlencode($osj2Dapplications->application_id->CurrentValue) ?>">Export to CSV</a>
<?php } ?>
<br><br>
<?php if ($osj2Dapplications->Export == "") { ?>
<a href="osj-osj2dapplicationslist.php">Back to List</a>&nbsp;
<?php if ($Security->CanAdd()) { ?>
<?php if (ShowOptionLink()) { ?>
<a href="osj-osj2dapplicationsadd.php">Add</a>&nbsp;
<?php } ?>
<?php } ?>
<?php if ($Security->CanEdit()) { ?>
<?php if (ShowOptionLink()) { ?>
<a href="<?php echo $osj2Dapplications->EditUrl() ?>">Edit</a>&nbsp;
<?php } ?>
<?php } ?>
<?php if ($Security->CanDelete()) { ?>
<?php if (ShowOptionLink()) { ?>
<a href="<?php echo $osj2Dapplications->DeleteUrl() ?>">Delete</a>&nbsp;
<?php } ?>
<?php } ?>
<?php } ?>
</span>
</p>
<?php
if (@$_SESSION[EW_SESSION_MESSAGE] <> "") {
?>
<p><span class="ewmsg"><?php echo $_SESSION[EW_SESSION_MESSAGE] ?></span></p>
<?php
	$_SESSION[EW_SESSION_MESSAGE] = ""; // Clear message
}
?>
<p>
<?php if ($osj2Dapplications->Export == "") { ?>
<form action="osj-osj2dapplicationsview.php" name="ewpagerform" id="ewpagerform">
<table border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td nowrap>
<span class="phpmaker">
<?php if (!isset($Pager)) $Pager = new cNumericPager($nStartRec, $nDisplayRecs, $nTotalRecs, $nRecRange) ?>
<?php if ($Pager->RecordCount > 0) { ?>
	<?php if ($Pager->FirstButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->FirstButton->Start ?>"><b>First</b></a>&nbsp;
	<?php } ?>
	<?php if ($Pager->PrevButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->PrevButton->Start ?>"><b>Previous</b></a>&nbsp;
	<?php } ?>
	<?php foreach ($Pager->Items as $PagerItem) { ?>
		<?php if ($PagerItem->Enabled) { ?><a href="osj-osj2dapplicationsview.php?start=<?php echo $PagerItem->Start ?>"><?php } ?><b><?php echo $PagerItem->Text ?></b><?php if ($PagerItem->Enabled) { ?></a><?php } ?>&nbsp;
	<?php } ?>
	<?php if ($Pager->NextButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->NextButton->Start ?>"><b>Next</b></a>&nbsp;
	<?php } ?>
	<?php if ($Pager->LastButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->LastButton->Start ?>"><b>Last</b></a>&nbsp;
	<?php } ?>
	<?php if ($Pager->ButtonCount > 0) { ?><br><?php } ?>
	Records <?php echo $Pager->FromIndex ?> to <?php echo $Pager->ToIndex ?> of <?php echo $Pager->RecordCount ?>
<?php } else { ?>	
	<?php if ($Security->CanList()) { ?>
	<?php if ($sSrchWhere == "0=101") { ?>
	Please enter search criteria
	<?php } else { ?>
	No records found
	<?php } ?>
	<?php } else { ?>
	You do not have the right permission to view the page
	<?php } ?>
<?php } ?>
</span>
		</td>
	</tr>
</table>
</form>
<?php } ?>
<form>
<table class="ewTable">
	<tr class="ewTableRow">
		<td class="ewTableHeader">Application ID</td>
		<td<?php echo $osj2Dapplications->application_id->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->application_id->ViewAttributes() ?>><?php echo $osj2Dapplications->application_id->ViewValue ?></div>
</td>
	</tr>
	<tr class="ewTableAltRow">
		<td class="ewTableHeader">User ID</td>
		<td<?php echo $osj2Dapplications->user_id->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->user_id->ViewAttributes() ?>><?php echo $osj2Dapplications->user_id->ViewValue ?></div>
</td>
	</tr>
	<tr class="ewTableRow">
		<td class="ewTableHeader">Resume</td>
		<td<?php echo $osj2Dapplications->resume_id->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->resume_id->ViewAttributes() ?>><?php echo $osj2Dapplications->resume_id->ViewValue ?></div>
</td>
	</tr>
	<tr class="ewTableAltRow">
		<td class="ewTableHeader">Post ID</td>
		<td<?php echo $osj2Dapplications->post_id->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->post_id->ViewAttributes() ?>><?php echo $osj2Dapplications->post_id->ViewValue ?></div>
</td>
	</tr>
	<tr class="ewTableRow">
		<td class="ewTableHeader">Application Date</td>
		<td<?php echo $osj2Dapplications->application_date->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->application_date->ViewAttributes() ?>><?php echo $osj2Dapplications->application_date->ViewValue ?></div>
</td>
	</tr>
	<tr class="ewTableAltRow">
		<td class="ewTableHeader">Application Email</td>
		<td<?php echo $osj2Dapplications->application_email->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->application_email->ViewAttributes() ?>><?php echo $osj2Dapplications->application_email->ViewValue ?></div>
</td>
	</tr>
	<tr class="ewTableRow">
		<td class="ewTableHeader">Application Comments</td>
		<td<?php echo $osj2Dapplications->application_text->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->application_text->ViewAttributes() ?>><?php echo $osj2Dapplications->application_text->ViewValue ?></div>
</td>
	</tr>
	<tr class="ewTableAltRow">
		<td class="ewTableHeader">Application Attachment</td>
		<td<?php echo $osj2Dapplications->application_file->CellAttributes() ?>>
<?php if ($osj2Dapplications->application_file->HrefValue <> "") { ?>
<?php if (!is_null($osj2Dapplications->application_file->Upload->DbValue)) { ?>
<a href="<?php echo $osj2Dapplications->application_file->HrefValue ?>" target="_blank"><?php echo $osj2Dapplications->application_file->ViewValue ?></a>
<?php } ?>
<?php } else { ?>
<?php if (!is_null($osj2Dapplications->application_file->Upload->DbValue)) { ?>
<?php echo $osj2Dapplications->application_file->ViewValue ?>
<?php } ?>
<?php } ?>
</td>
	</tr>
	<tr class="ewTableRow">
		<td class="ewTableHeader">Application File Name</td>
		<td<?php echo $osj2Dapplications->application_file_name->CellAttributes() ?>>
<div<?php echo $osj2Dapplications->application_file_name->ViewAttributes() ?>><?php echo $osj2Dapplications->application_file_name->ViewValue ?></div>
</td>
	</tr>
</table>
</form>
<?php if ($osj2Dapplications->Export == "") { ?>
<form action="osj-osj2dapplicationsview.php" name="ewpagerform" id="ewpagerform">
<table border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td nowrap>
<span class="phpmaker">
<?php if (!isset($Pager)) $Pager = new cNumericPager($nStartRec, $nDisplayRecs, $nTotalRecs, $nRecRange) ?>
<?php if ($Pager->RecordCount > 0) { ?>
	<?php if ($Pager->FirstButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->FirstButton->Start ?>"><b>First</b></a>&nbsp;
	<?php } ?>
	<?php if ($Pager->PrevButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->PrevButton->Start ?>"><b>Previous</b></a>&nbsp;
	<?php } ?>
	<?php foreach ($Pager->Items as $PagerItem) { ?>
		<?php if ($PagerItem->Enabled) { ?><a href="osj-osj2dapplicationsview.php?start=<?php echo $PagerItem->Start ?>"><?php } ?><b><?php echo $PagerItem->Text ?></b><?php if ($PagerItem->Enabled) { ?></a><?php } ?>&nbsp;
	<?php } ?>
	<?php if ($Pager->NextButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->NextButton->Start ?>"><b>Next</b></a>&nbsp;
	<?php } ?>
	<?php if ($Pager->LastButton->Enabled) { ?>
	<a href="osj-osj2dapplicationsview.php?start=<?php echo $Pager->LastButton->Start ?>"><b>Last</b></a>&nbsp;
	<?php } ?>
	<?php if ($Pager->ButtonCount > 0) { ?><br><?php } ?>
	Records <?php echo $Pager->FromIndex ?> to <?php echo $Pager->ToIndex ?> of <?php echo $Pager->RecordCount ?>
<?php } else { ?>	
	<?php if ($Security->CanList()) { ?>
	<?php if ($sSrchWhere == "0=101") { ?>
	Please enter search criteria
	<?php } else { ?>
	No records found
	<?php } ?>
	<?php } else { ?>
	You do not have the right permission to view the page
	<?php } ?>
<?php } ?>
</span>
		</td>
	</tr>
</table>
</form>
<?php } ?>
<p>
<script language="JavaScript" type="text/javascript">
<!--

// Write your table-specific startup script here
// document.write("page loaded");
//-->

</script>
<?php include "osj-footer.php" ?>
<?php

// If control is passed here, simply terminate the page without redirect
Page_Terminate();

// -----------------------------------------------------------------
//  Subroutine Page_Terminate
//  - called when exit page
//  - clean up connection and objects
//  - if url specified, redirect to url, otherwise end response
function Page_Terminate($url = "") {
	global $conn;

	// Page unload event, used in current page
	Page_Unload();

	// Global page unloaded event (in userfn*.php)
	Page_Unloaded();

	 // Close Connection
	$conn->Close();

	// Go to url if specified
	if ($url <> "") {
		ob_end_clean();
		header("Location: $url");
	}
	exit();
}
?>
<?php

// Load recordset
function LoadRecordset($offset = -1, $rowcnt = -1) {
	global $conn, $osj2Dapplications;

	// Call Recordset Selecting event
	$osj2Dapplications->Recordset_Selecting($osj2Dapplications->CurrentFilter);

	// Load list page sql
	$sSql = $osj2Dapplications->SelectSQL();
	if ($offset > -1 && $rowcnt > -1) $sSql .= " LIMIT $offset, $rowcnt";

	// Load recordset
	$conn->raiseErrorFn = 'ew_ErrorFn';	
	$rs = $conn->Execute($sSql);
	$conn->raiseErrorFn = '';

	// Call Recordset Selected event
	$osj2Dapplications->Recordset_Selected($rs);
	return $rs;
}
?>
<?php

// Load row based on key values
function LoadRow() {
	global $conn, $Security, $osj2Dapplications;
	$sFilter = $osj2Dapplications->SqlKeyFilter();
	if (!is_numeric($osj2Dapplications->application_id->CurrentValue)) {
		return FALSE; // Invalid key, exit
	}
	$sFilter = str_replace("@application_id@", ew_AdjustSql($osj2Dapplications->application_id->CurrentValue), $sFilter); // Replace key value
	if ($Security->CurrentUserID() <> "" && !$Security->IsAdmin()) { // Non system admin
		$sFilter = $osj2Dapplications->AddUserIDFilter($sFilter, $Security->CurrentUserID()); // Add User ID filter
	}

	// Call Row Selecting event
	$osj2Dapplications->Row_Selecting($sFilter);

	// Load sql based on filter
	$osj2Dapplications->CurrentFilter = $sFilter;
	$sSql = $osj2Dapplications->SQL();
	if ($rs = $conn->Execute($sSql)) {
		if ($rs->EOF) {
			$LoadRow = FALSE;
		} else {
			$LoadRow = TRUE;
			$rs->MoveFirst();
			LoadRowValues($rs); // Load row values

			// Call Row Selected event
			$osj2Dapplications->Row_Selected($rs);
		}
		$rs->Close();
	} else {
		$LoadRow = FALSE;
	}
	return $LoadRow;
}

// Load row values from recordset
function LoadRowValues(&$rs) {
	global $osj2Dapplications;
	$osj2Dapplications->application_id->setDbValue($rs->fields('application_id'));
	$osj2Dapplications->user_id->setDbValue($rs->fields('user_id'));
	$osj2Dapplications->resume_id->setDbValue($rs->fields('resume_id'));
	$osj2Dapplications->post_id->setDbValue($rs->fields('post_id'));
	$osj2Dapplications->application_date->setDbValue($rs->fields('application_date'));
	$osj2Dapplications->application_email->setDbValue($rs->fields('application_email'));
	$osj2Dapplications->application_text->setDbValue($rs->fields('application_text'));
	$osj2Dapplications->application_file->Upload->DbValue = $rs->fields('application_file');
	$osj2Dapplications->application_file_name->setDbValue($rs->fields('application_file_name'));
}
?>
<?php

// Render row values based on field settings
function RenderRow() {
	global $conn, $Security, $osj2Dapplications;

	// Call Row Rendering event
	$osj2Dapplications->Row_Rendering();

	// Common render codes for all row types
	// application_id

	$osj2Dapplications->application_id->CellCssStyle = "";
	$osj2Dapplications->application_id->CellCssClass = "";

	// user_id
	$osj2Dapplications->user_id->CellCssStyle = "";
	$osj2Dapplications->user_id->CellCssClass = "";

	// resume_id
	$osj2Dapplications->resume_id->CellCssStyle = "";
	$osj2Dapplications->resume_id->CellCssClass = "";

	// post_id
	$osj2Dapplications->post_id->CellCssStyle = "";
	$osj2Dapplications->post_id->CellCssClass = "";

	// application_date
	$osj2Dapplications->application_date->CellCssStyle = "";
	$osj2Dapplications->application_date->CellCssClass = "";

	// application_email
	$osj2Dapplications->application_email->CellCssStyle = "";
	$osj2Dapplications->application_email->CellCssClass = "";

	// application_text
	$osj2Dapplications->application_text->CellCssStyle = "";
	$osj2Dapplications->application_text->CellCssClass = "";

	// application_file
	$osj2Dapplications->application_file->CellCssStyle = "";
	$osj2Dapplications->application_file->CellCssClass = "";

	// application_file_name
	$osj2Dapplications->application_file_name->CellCssStyle = "";
	$osj2Dapplications->application_file_name->CellCssClass = "";
	if ($osj2Dapplications->RowType == EW_ROWTYPE_VIEW) { // View row

		// application_id
		$osj2Dapplications->application_id->ViewValue = $osj2Dapplications->application_id->CurrentValue;
		$osj2Dapplications->application_id->CssStyle = "";
		$osj2Dapplications->application_id->CssClass = "";
		$osj2Dapplications->application_id->ViewCustomAttributes = "";

		// user_id
		$osj2Dapplications->user_id->ViewValue = $osj2Dapplications->user_id->CurrentValue;
		$osj2Dapplications->user_id->CssStyle = "";
		$osj2Dapplications->user_id->CssClass = "";
		$osj2Dapplications->user_id->ViewCustomAttributes = "";

		// resume_id
		if (!is_null($osj2Dapplications->resume_id->CurrentValue)) {
			$sSqlWrk = "SELECT `resume_title` FROM `osj-resumes` WHERE `resume_id` = " . ew_AdjustSql($osj2Dapplications->resume_id->CurrentValue) . "";
			$sSqlWrk .= " AND (" . "`user_id` = ".CurrentUserID()."" . ")";
			$sSqlWrk .= " ORDER BY `resume_title` Asc";
			$rswrk = $conn->Execute($sSqlWrk);
			if ($rswrk) {
				if (!$rswrk->EOF) {
					$osj2Dapplications->resume_id->ViewValue = $rswrk->fields('resume_title');
				}
				$rswrk->Close();
			} else {
				$osj2Dapplications->resume_id->ViewValue = $osj2Dapplications->resume_id->CurrentValue;
			}
		} else {
			$osj2Dapplications->resume_id->ViewValue = NULL;
		}
		$osj2Dapplications->resume_id->CssStyle = "";
		$osj2Dapplications->resume_id->CssClass = "";
		$osj2Dapplications->resume_id->ViewCustomAttributes = "";

		// post_id
		$osj2Dapplications->post_id->ViewValue = $osj2Dapplications->post_id->CurrentValue;
		$osj2Dapplications->post_id->CssStyle = "";
		$osj2Dapplications->post_id->CssClass = "";
		$osj2Dapplications->post_id->ViewCustomAttributes = "";

		// application_date
		$osj2Dapplications->application_date->ViewValue = $osj2Dapplications->application_date->CurrentValue;
		$osj2Dapplications->application_date->ViewValue = ew_FormatDateTime($osj2Dapplications->application_date->ViewValue, 6);
		$osj2Dapplications->application_date->CssStyle = "";
		$osj2Dapplications->application_date->CssClass = "";
		$osj2Dapplications->application_date->ViewCustomAttributes = "";

		// application_email
		$osj2Dapplications->application_email->ViewValue = $osj2Dapplications->application_email->CurrentValue;
		$osj2Dapplications->application_email->CssStyle = "";
		$osj2Dapplications->application_email->CssClass = "";
		$osj2Dapplications->application_email->ViewCustomAttributes = "";

		// application_text
		$osj2Dapplications->application_text->ViewValue = $osj2Dapplications->application_text->CurrentValue;
		if (!is_null($osj2Dapplications->application_text->ViewValue)) $osj2Dapplications->application_text->ViewValue = str_replace("\n", "<br>", $osj2Dapplications->application_text->ViewValue); 
		$osj2Dapplications->application_text->CssStyle = "";
		$osj2Dapplications->application_text->CssClass = "";
		$osj2Dapplications->application_text->ViewCustomAttributes = "";

		// application_file
		if (!is_null($osj2Dapplications->application_file->Upload->DbValue)) {
			$osj2Dapplications->application_file->ViewValue = "Application Attachment";
		} else {
			$osj2Dapplications->application_file->ViewValue = "";
		}
		$osj2Dapplications->application_file->CssStyle = "";
		$osj2Dapplications->application_file->CssClass = "";
		$osj2Dapplications->application_file->ViewCustomAttributes = "";

		// application_file_name
		$osj2Dapplications->application_file_name->ViewValue = $osj2Dapplications->application_file_name->CurrentValue;
		$osj2Dapplications->application_file_name->CssStyle = "";
		$osj2Dapplications->application_file_name->CssClass = "";
		$osj2Dapplications->application_file_name->ViewCustomAttributes = "";

		// application_id
		$osj2Dapplications->application_id->HrefValue = "";

		// user_id
		$osj2Dapplications->user_id->HrefValue = "";

		// resume_id
		$osj2Dapplications->resume_id->HrefValue = "";

		// post_id
		$osj2Dapplications->post_id->HrefValue = "";

		// application_date
		$osj2Dapplications->application_date->HrefValue = "";

		// application_email
		$osj2Dapplications->application_email->HrefValue = "";

		// application_text
		$osj2Dapplications->application_text->HrefValue = "";

		// application_file
		if (!is_null($osj2Dapplications->application_file->Upload->DbValue)) {
			$osj2Dapplications->application_file->HrefValue = "osj-osj2dapplications_application_file_bv.php?application_id=" . $osj2Dapplications->application_id->CurrentValue;
			if ($osj2Dapplications->Export <> "") $osj2Dapplications->application_file->HrefValue = ew_ConvertFullUrl($osj2Dapplications->application_file->HrefValue);
		} else {
			$osj2Dapplications->application_file->HrefValue = "";
		}

		// application_file_name
		$osj2Dapplications->application_file_name->HrefValue = "";
	} elseif ($osj2Dapplications->RowType == EW_ROWTYPE_ADD) { // Add row
	} elseif ($osj2Dapplications->RowType == EW_ROWTYPE_EDIT) { // Edit row
	} elseif ($osj2Dapplications->RowType == EW_ROWTYPE_SEARCH) { // Search row
	}

	// Call Row Rendered event
	$osj2Dapplications->Row_Rendered();
}
?>
<?php

// Export data in Xml or Csv format
function ExportData() {
	global $nTotalRecs, $nStartRec, $nStopRec, $nTotalRecs, $nDisplayRecs, $osj2Dapplications;
	$sCsvStr = "";
	$rs = LoadRecordset();
	$nTotalRecs = $rs->RecordCount();
	$nStartRec = 1;
		SetUpStartRec(); // Set Up Start Record Position

		// Set the last record to display
		if ($nDisplayRecs < 0) {
			$nStopRec = $nTotalRecs;
		} else {
			$nStopRec = $nStartRec + $nDisplayRecs - 1;
		}
	if ($osj2Dapplications->Export == "xml") {
		$XmlDoc = new cXMLDocument();
	}
	if ($osj2Dapplications->Export == "csv") {
		$sCsvStr .= "application_id" . ",";
		$sCsvStr .= "user_id" . ",";
		$sCsvStr .= "resume_id" . ",";
		$sCsvStr .= "post_id" . ",";
		$sCsvStr .= "application_date" . ",";
		$sCsvStr .= "application_email" . ",";
		$sCsvStr .= "application_text" . ",";
		$sCsvStr .= "application_file_name" . ",";
		$sCsvStr = substr($sCsvStr, 0, strlen($sCsvStr)-1); // Remove last comma
		$sCsvStr .= "\n";
	}

	// Move to first record directly for performance reason
	$nRecCount = $nStartRec - 1;
	if (!$rs->EOF) {
		$rs->MoveFirst();
		$rs->Move($nStartRec - 1);
	}
	while (!$rs->EOF && $nRecCount < $nStopRec) {
		$nRecCount++;
		if (intval($nRecCount) >= intval($nStartRec)) {
			LoadRowValues($rs);
			if ($osj2Dapplications->Export == "xml") {
				$XmlDoc->BeginRow();
				$XmlDoc->AddField('application_id', $osj2Dapplications->application_id->CurrentValue);
				$XmlDoc->AddField('user_id', $osj2Dapplications->user_id->CurrentValue);
				$XmlDoc->AddField('resume_id', $osj2Dapplications->resume_id->CurrentValue);
				$XmlDoc->AddField('post_id', $osj2Dapplications->post_id->CurrentValue);
				$XmlDoc->AddField('application_date', $osj2Dapplications->application_date->CurrentValue);
				$XmlDoc->AddField('application_email', $osj2Dapplications->application_email->CurrentValue);
				$XmlDoc->AddField('application_text', $osj2Dapplications->application_text->CurrentValue);
				$XmlDoc->AddField('application_file_name', $osj2Dapplications->application_file_name->CurrentValue);
				$XmlDoc->EndRow();
			}
			if ($osj2Dapplications->Export == "csv") {
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->application_id->CurrentValue)) . '",';
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->user_id->CurrentValue)) . '",';
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->resume_id->CurrentValue)) . '",';
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->post_id->CurrentValue)) . '",';
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->application_date->CurrentValue)) . '",';
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->application_email->CurrentValue)) . '",';
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->application_text->CurrentValue)) . '",';
				$sCsvStr .= '"' . str_replace('"', '""', strval($osj2Dapplications->application_file_name->CurrentValue)) . '",';
				$sCsvStr = substr($sCsvStr, 0, strlen($sCsvStr)-1); // Remove last comma
				$sCsvStr .= "\n";
			}
		}
		$rs->MoveNext();
	}

	// Close recordset
	$rs->Close();
	if ($osj2Dapplications->Export == "xml") {
		header("Content-Type: text/xml");
		echo $XmlDoc->XML();
	}
	if ($osj2Dapplications->Export == "csv") {
		echo $sCsvStr;
	}
}
?>
<?php

// Show link optionally based on User ID
function ShowOptionLink() {
	global $Security, $osj2Dapplications;
	if ($Security->IsLoggedIn()) {
		if (!$Security->IsAdmin()) {
			return $Security->IsValidUserID($osj2Dapplications->user_id->CurrentValue);
		}
	}
	return TRUE;
}
?>
<?php

// Set up Starting Record parameters based on Pager Navigation
function SetUpStartRec() {
	global $nDisplayRecs, $nStartRec, $nTotalRecs, $nPageNo, $osj2Dapplications;
	if ($nDisplayRecs == 0) return;

	// Check for a START parameter
	if (@$_GET[EW_TABLE_START_REC] <> "") {
		$nStartRec = $_GET[EW_TABLE_START_REC];
		$osj2Dapplications->setStartRecordNumber($nStartRec);
	} elseif (@$_GET[EW_TABLE_PAGE_NO] <> "") {
		$nPageNo = $_GET[EW_TABLE_PAGE_NO];
		if (is_numeric($nPageNo)) {
			$nStartRec = ($nPageNo-1)*$nDisplayRecs+1;
			if ($nStartRec <= 0) {
				$nStartRec = 1;
			} elseif ($nStartRec >= intval(($nTotalRecs-1)/$nDisplayRecs)*$nDisplayRecs+1) {
				$nStartRec = intval(($nTotalRecs-1)/$nDisplayRecs)*$nDisplayRecs+1;
			}
			$osj2Dapplications->setStartRecordNumber($nStartRec);
		} else {
			$nStartRec = $osj2Dapplications->getStartRecordNumber();
		}
	} else {
		$nStartRec = $osj2Dapplications->getStartRecordNumber();
	}

	// Check if correct start record counter
	if (!is_numeric($nStartRec) || $nStartRec == "") { // Avoid invalid start record counter
		$nStartRec = 1; // Reset start record counter
		$osj2Dapplications->setStartRecordNumber($nStartRec);
	} elseif (intval($nStartRec) > intval($nTotalRecs)) { // Avoid starting record > total records
		$nStartRec = intval(($nTotalRecs-1)/$nDisplayRecs)*$nDisplayRecs+1; // Point to last page first record
		$osj2Dapplications->setStartRecordNumber($nStartRec);
	} elseif (($nStartRec-1) % $nDisplayRecs <> 0) {
		$nStartRec = intval(($nStartRec-1)/$nDisplayRecs)*$nDisplayRecs+1; // Point to page boundary
		$osj2Dapplications->setStartRecordNumber($nStartRec);
	}
}
?>
<?php

// Page Load event
function Page_Load() {

	//echo "Page Load";
}

// Page Unload event
function Page_Unload() {

	//echo "Page Unload";
}
?>
